class CreateReports < ActiveRecord::Migration
  def self.up
    create_table :reports do |t|
      t.integer :source_id # twitter, news feed, etc.
      t.string :author
      t.string :url
      t.decimal :lat, :precision => 20, :scale => 15
      t.decimal :lng, :precision => 20, :scale => 15
      t.text :title
      t.text :content
      t.text :notes
      t.datetime :authored_at

      t.timestamps
    end
  end

  def self.down
    drop_table :reports
  end
end
